Agent Central Host Computer/Agent - Central Host Computer.iso/_SETUP.1/vckcashbox.sql

Text File | 2000-05-12 | 332b | 8 lines

CREATE OR REPLACE VIEW VCKCASHBOX AS
SELECT distinct CURSTATE.CURRENT_CASHBOX_ID,  curstate.FAREBOX_GLID,
curstate.PROBE_CONTEXT_ID
from curstate
where curstate.CURRENT_CASHBOX_ID not like '000000%' and  not exists (select  cashbox.cashbox_glID
from  cashbox where CASHBOX.CB_SERNUM = CURSTATE.CURRENT_CASHBOX_ID);